if exists (select 1 from sysobjects where name = 'del_beschreibung' and type = 'P')
begin
   drop procedure del_beschreibung
   print 'Procedure: del_beschreibung deleted ...'
end
go
create procedure del_beschreibung(
  @beschrid          int           = 6
)
as
begin
  set nocount on
  delete from Beschreibung where BeschrID = @beschrid
end
go
print 'Procedure: del_beschreibung done ...'
go
grant exec on del_beschreibung to prsadmins with grant option
go
grant exec on del_beschreibung to prsusers
go

